-- Deprecated, but left here because mutating the migration is the eighth deadly sin
BEGIN;
	CREATE TABLE comments(
		id BIGSERIAL PRIMARY KEY,
		owner_type VARCHAR NOT NULL,
		owner_id BIGINT NOT NULL,
		facebook_user_id BIGINT NOT NULL,
		content TEXT,
		created_at TIMESTAMPTZ DEFAULT now()
	);
	CREATE INDEX comments_facebook_user_id_index ON comments (facebook_user_id,created_at);
	CREATE INDEX comments_owner_index ON comments (owner_type,owner_id,created_at);
END;
